Export data to CSV

You can export numbers, customers and SIP connections from the Service portal to a CSV file. Each export includes the rows shown in the page, with the current filters applied. Phone numbers are written in a format that keeps the leading + sign when the file is opened in Excel. A numbers export covers the numbers of one customer. It can contain up to 200,000 numbers, and up to two numbers exports can run at the same time.

See also Export SIP Connections.

➢ To export numbers:
1. Do one of the following:
● In the Numbers Management page, click Export CSV. In the Export CSV dialog, select the customer and then click Export.
● In the Customer Leads page, open the ... menu of the customer and then choose Export Numbers CSV.
2. Save the file. The file includes the following columns, depending on the service: Number, Service Name, Customer SIP Connection, Associated Trunk, Zoom SIP Connection, Zoom Account Number, Number type, Status, Location and Modified On.

If the customer has more than 200,000 numbers, the message "Too many numbers to export" is displayed. Narrow the filter and try again.

➢ To export customers:
1. In the Customer Leads page, click the All Customers tab.
2. Filter the table as required and then click Export CSV.

If usage data has not yet been calculated for some customers, a message asks whether to download partial data. Click Download Anyway to continue, or Cancel to try again later.

3. Save the file. The file includes the customer details (for example, Full name, Service Name, Customer, Status, Contact Name, Contact Email, Phone Number, Consented On and Last Modified) and the usage columns for the service (for example, Total Numbers and Total CAC). Usage columns that are calculated daily are marked with an asterisk (*).